package com.authine.cloudpivot.web.api.secondopen.dao;

import com.authine.cloudpivot.web.api.secondopen.domain.IdList;
import com.authine.cloudpivot.web.api.secondopen.domain.Iusi6cgb;
import com.authine.cloudpivot.web.api.secondopen.modules.LxfwdVo;
import com.authine.cloudpivot.web.api.secondopen.modules.LxwxgcdVO;
import com.authine.cloudpivot.web.api.secondopen.modules.PurchaseOrderDTO;
import com.authine.cloudpivot.web.api.secondopen.modules.SporadicServicesVO;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface Iusi6cgbMapper {
    /**
     * 零修/铆焊---采购订单查询
     * @param supplier
     * @param stime
     * @param etime
     * @param sqlx
     * @return
     */
    public List<Iusi6cgb> queryPurchaseOrder(String supplier, String stime, String etime, String sqlx);

    /**
     * 修改零修铆焊件子表状态
     * @param idList
     * @return
     */
    public int updatecgbStatus(List list,String status);

    /**
     * 零星维修工程修改状态
     * @param list
     * @param status
     * @return
     */
    int updatelxwxgcStatus(List list,String status);

    /**
     * 零星服务申请修改状态
     * @param idList
     * @return
     */
    int updatelxfwStatus(List list,String status);
    public int creacreateItemNumber(IdList idList);

    /**
     * 修改申购单状态
     * @param idList
     * @return
     */
    public int updateRequisitionsStatus(@Param("idList") IdList idList,@Param("tableName") String tableName);

    /**
     * 零星服务采购订单查询
     */
    List<SporadicServicesVO>  querylxfwPurchaseOrder(@Param("dto") PurchaseOrderDTO orderDTO);

    /**
     * 零星维修工程采购单查询
     */
    List<LxwxgcdVO> querylxwxgc(@Param("gys") String gys);

    /**
     * 零星服务采购单查询
     */
    List<LxfwdVo> querylxfwsq(@Param("gys") String gys);

    /**
     * 根据部门id查询名称
     */
    String querybmmcById(String id);

    /**
     * 根据id查询工号
     */
    String getJobNumberById(String id);

    /**
     * 根据id查询mes号
     */
    String getMesByJobNumber(String id);

}